<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>Provide data for a chart</title>
    <link rel="StyleSheet" href="css/ChartBasics.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="ch-TutT2AddTheChartToTheReport.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="ch-TutT4EnlargeChartAndPreview.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h3 class="N_TutorialTask">Task 3:&nbsp;&nbsp;<a name="352845">Provide data for a chart</a></h3>
      <p class="b1i_Bullet1-intro"><a name="352847">In task 1, you created the data source connection and data set that you need. After selecting the data set to use, you must set up the expressions that the chart uses to represent the data graphically. Each type of chart uses data differently. For a pie chart, you must select data expressions that specify:</a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="226558">The data values represented by sectors in the pie. In this tutorial, you use an expression that creates one sector for each product line value. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="226559">The size of each sector. In this tutorial, the number of orders determines the size of each product-line sector. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="b_Body"><a name="226574">You can use different techniques to provide a data expression in a chart. The easiest way to specify the data to use is to drag a column from Data Preview to a field. You can also type the expression or use expression builder to create an expression.</a></p>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="402726">To navigate to the page you use to provide data, choose Select Data. The upper half of Select Data, shown in </a><a href="#402109" title="Provide data for a chart">Figure&nbsp;13-4</a>, provides a chart preview.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="402107"><img class="Default" src="images/CHT_TSelectDatatop.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 13-4 Previewing the chart in the upper section of Select Data" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;13-4&nbsp;&nbsp;</b><a name="402109">Previewing the chart in the upper section of Select Data</a></div>
      <div class="N_i_Indent1"><a name="399280">Chart Preview displays a rough sketch of the chart for design purposes. The final published version looks more elaborate and complete, particularly if you choose to use live data for previews. In Chart Preview, the chart builder uses either live data from your data set or randomly generated sample data, depending on how you set the Enable Live Preview preference.</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="399291">In the lower half of the Select Data page, select:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="cfi_CodeFirstIndent"><a name="399292">Use Data from</a></div>
      <div class="N_i_Indent1"><a name="399377">This report design includes only one data set. Select ChartData from the drop-down list. Select the Show data preview option if it is not selected. In the lower half of the chart builder, as shown in </a><a href="#399390" title="Provide data for a chart">Figure&nbsp;13-5</a>, Data Preview displays some of the data from the data set.</div>
      <p class="i2_Image2"><a name="399388"><img class="Default" src="images/ChartBasics.13.5.2.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 13-5 Selecting a data set in the lower section of Select Data" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;13-5&nbsp;&nbsp;</b><a name="399390">Selecting a data set in the lower section of Select Data </a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="357558">In Data Preview, select the PRODUCTLINE column heading, and drag it to the empty Category Definition field, as shown in </a><a href="#223859" title="Provide data for a chart">Figure&nbsp;13-6</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="357568"><img class="Default" src="images/ChartBasics.13.5.3.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 13-6 Supplying a category definition" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;13-6&nbsp;&nbsp;</b><a name="223859">Supplying a category definition</a></div>
      <div class="N_i_Indent1"><a name="213066">A slice appears in the pie chart for each item in the category. The following expression appears in Category Definition:</a></div>
      <div class="cfi_CodeFirstIndent"><a name="168460">row["PRODUCTLINE"]</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="253149">To set the size of each sector, select the TotalOrders column header, and drag it to the empty field in Slice Size Definition, as shown in </a><a href="#253162" title="Provide data for a chart">Figure&nbsp;13-7</a>. </div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="253160"><img class="Default" src="images/CHT_TData3-2new.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 13-7 Supplying a slice size definition" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;13-7&nbsp;&nbsp;</b><a name="253162">Supplying a slice size definition</a></div>
      <div class="N_i_Indent1"><a name="168545">The following expression appears in Slice Size Definition: </a></div>
      <div class="cfi_CodeFirstIndent"><a name="168546">row["TOTALORDERS"]</a></div>
      <div class="N_i_Indent1"><a name="168547">In Data Preview, the TotalOrders column is colored to show that the chart uses the column. The image in Chart Preview changes to reflect the data you specified. The product lines are now the chart categories. The size of the sectors represents the total orders for each product line category. </a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>